UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L9JBcMMCPWORYix/v8dOGYO55QspZsxbks0HzyiK2Bk='
WHERE
key_id = 'f529427240fec307376e7de51266dfab868b2a5d08ceb4b4a2665c0970e1a6cd'
AND (
token = 'L9JBcMMCPWORYix/v8dOGYO55QspZsxbks0HzyiK2Bk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)