UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KofdK6A0iD45YfypoNPFYFRnmUn/TWbsBbr0EES7auA='
WHERE
key_id = '6196e7e00fce6ce6c1a4140625a9cf86aec74db79b95255e6cbce44ffc9e131a'
AND (
token = 'KofdK6A0iD45YfypoNPFYFRnmUn/TWbsBbr0EES7auA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)