UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7WuXi5Cf/2v8ytkvz5BUmVb8aNmpqoG1ab5zfJ15krg='
WHERE
key_id = '851c506a71b4e5c3b45a80f3512882c999df70a59056ab0f33a9b813ed562385'
AND (
token = '7WuXi5Cf/2v8ytkvz5BUmVb8aNmpqoG1ab5zfJ15krg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)