UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D7yA7/rdML9V4lV5yES5LXEKPwqBn/FsHSr/N2fWuDw='
WHERE
key_id = 'a82dab9c4bb3b102674815f04eeba4d6426401c08a0b9f16e73816a9515eba3e'
AND (
token = 'D7yA7/rdML9V4lV5yES5LXEKPwqBn/FsHSr/N2fWuDw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)