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