UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '49e5DG5oNqnV+7MO3+SV67JYAHBN30wUaKgIu4rdBug='
WHERE
key_id = '24edc062421895993a729a73426ff7c94d94b9eca604c8f2c109085351589216'
AND (
token = '49e5DG5oNqnV+7MO3+SV67JYAHBN30wUaKgIu4rdBug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)