UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ApYwnt8NtXdfRIwzIOxczIsqSulcNBHONT+8iehdcPs='
WHERE
key_id = '0cb1ea6b86a91be13069bb60c716c30f406b0b730fb6d9c46be0b72e2e17b4d2'
AND (
token = 'ApYwnt8NtXdfRIwzIOxczIsqSulcNBHONT+8iehdcPs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)