UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47/rghfDIr59cID6/b1fzgz/McfobjHk2an2kTRt4PU='
WHERE
key_id = '2e4c3922e68798cf43ca0d2365715c96c57bd0750366ce2300b2620610e87435'
AND (
token = '47/rghfDIr59cID6/b1fzgz/McfobjHk2an2kTRt4PU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)