UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0kd2kY8WvCeYOH4PdrTwnPEGHvTRt7p3V5bpg9wI5i8='
WHERE
key_id = 'c0a4068486509f6e70a1585e3ce0c1071304f6c6bb5fa84f89b2e7c9a00b746d'
AND (
token = '0kd2kY8WvCeYOH4PdrTwnPEGHvTRt7p3V5bpg9wI5i8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)