UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iY+9RmH/40WUXrPCQ2bmb4gVzbGgynsWTRNB7m4BaV4='
WHERE
key_id = '8d47a31a9960cd56595986eeaf5a940a6019d0920fe5d809481540a3e93a9b85'
AND (
token = 'iY+9RmH/40WUXrPCQ2bmb4gVzbGgynsWTRNB7m4BaV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)