UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cLL2NAmV0xsPLPgFL9e2+8+fl+G0orV9uA39rooRoTk='
WHERE
key_id = 'a3857ef92c76eec89459a41996609ace001531e0b958563d2a910051d9a8dfbf'
AND (
token = 'cLL2NAmV0xsPLPgFL9e2+8+fl+G0orV9uA39rooRoTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)