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