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