UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0iaYe7VkNXfVj6HTcyqsjd+oqqIGY/MSIt73QMerXrg='
WHERE
key_id = 'e94e3ebafcc5b90eaa6fa174f8b02533cf49d085459a652ec54f99d8df27da53'
AND (
token = '0iaYe7VkNXfVj6HTcyqsjd+oqqIGY/MSIt73QMerXrg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)