UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lmga4G2Dg1ydDYPgybKu+9awXGi/TIbGx93r9flF1oQ='
WHERE
key_id = '42cae4c9a412abdc6b7cfcd72d8399b479fb6ae6570afd366db0ad3df6faa144'
AND (
token = 'Lmga4G2Dg1ydDYPgybKu+9awXGi/TIbGx93r9flF1oQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)