UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dC9/DRe8h5xJNtYtMNd6ImVpSWjMP7qp/LWCBz620+E='
WHERE
key_id = '6741d9f9e52f3a38a8dece11ce61d0d8f02019ddbdf65d8f2f26d8df0d5a0aed'
AND (
token = 'dC9/DRe8h5xJNtYtMNd6ImVpSWjMP7qp/LWCBz620+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)