UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b9ZgK0CB8ZLvT+oSu8gJHEeetDUEE6I8v55MzcsM2Rk='
WHERE
key_id = '24eb8a53fc45bb8399b3a37caf0e7698fb0b858994fbf882586f9e4a0bcc6488'
AND (
token = 'b9ZgK0CB8ZLvT+oSu8gJHEeetDUEE6I8v55MzcsM2Rk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)