UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dhSmPo0CupOTjj+CUehHBzgIXMFSsO/n1WT2w8nIxwA='
WHERE
key_id = '6c63d159bbd564f600c43aee86959e8d0566985efcb5162d19a42805f9358c73'
AND (
token = 'dhSmPo0CupOTjj+CUehHBzgIXMFSsO/n1WT2w8nIxwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)