UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GiKIhE1oaI3ThGKPseUWlWcwzb8KeCcjeKRH/XDwBaM='
WHERE
key_id = 'a4c2d046b08a8f02b5be242cd7a2b5dcfd8ca8b02aeb4f5bf98d048dd20cc079'
AND (
token = 'GiKIhE1oaI3ThGKPseUWlWcwzb8KeCcjeKRH/XDwBaM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)