UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VgfTn4QnJQfKe3iKFSwH1OoQbcZ6YK7FwXNSpY8SjjE='
WHERE
key_id = '2445deef50c82cb504c9a42f6bdcaf261e50125e144ffa97066b4be1589869ed'
AND (
token = 'VgfTn4QnJQfKe3iKFSwH1OoQbcZ6YK7FwXNSpY8SjjE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)