UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z1lh04gCTRwHTI7tXa3H7OkIuYb3JFMcSRtBOzp3EYU='
WHERE
key_id = '7767bc5f0f8cff82a3053a7146eb177374971f80de5f4910d3e3d7e3831e868a'
AND (
token = 'Z1lh04gCTRwHTI7tXa3H7OkIuYb3JFMcSRtBOzp3EYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)