UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7BzjYvZo81Yd4AhG0oD7LBhmJPQhWTG/uBwv4dSk9J4='
WHERE
key_id = '3fa0910ab3317f24d367dc6923366f20c857967b0c3d635f9dc393441c251765'
AND (
token = '7BzjYvZo81Yd4AhG0oD7LBhmJPQhWTG/uBwv4dSk9J4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)