UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MkNZDJVDfP2faX+EGZf0Q20wwh4QSOC6lrEaq1QFJVs='
WHERE
key_id = 'd803029c2db07524e5cc1590497f4231604f6636b8b5984634cdc2aa0c123194'
AND (
token = 'MkNZDJVDfP2faX+EGZf0Q20wwh4QSOC6lrEaq1QFJVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)