UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'psBDwc1z32n06xlwaw3einz1Z2F3iZZF0yfsT9GZWmA='
WHERE
key_id = 'f0f0efaadf583a8eb2144372280bc941ab0b0f0eafc5b5e04038b4c5379b6640'
AND (
token = 'psBDwc1z32n06xlwaw3einz1Z2F3iZZF0yfsT9GZWmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)