UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yI9dsW7O2sg7xXeNUY54kG4jiOAESthBYadYLFcXkOs='
WHERE
key_id = '5641207b3c012f95ec5dd04fa10243e42fb8d0a0e2619ef055930b772decb63c'
AND (
token = 'yI9dsW7O2sg7xXeNUY54kG4jiOAESthBYadYLFcXkOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)