UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TPGS9tpo2qUWtvxJSyCmAudxOg3mx+4VOaDw2dJTRXc='
WHERE
key_id = 'c3eb2b6e34f53a3a5e8f0b08c667b9ebd3abf1f46d9a49cd60565e6dc733ebb6'
AND (
token = 'TPGS9tpo2qUWtvxJSyCmAudxOg3mx+4VOaDw2dJTRXc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)