UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7N1pS/cT1Ngm7b0WHigdh+yZJVWSbcURxLEKKmiwsDM='
WHERE
key_id = '23b1411fee6839b4b76e05b6148d2d594d9d45d5133b6d27f5fbe9333463a33c'
AND (
token = '7N1pS/cT1Ngm7b0WHigdh+yZJVWSbcURxLEKKmiwsDM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)