UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C6+sKTgHUzynq35QLpshOUg1Xh8YuLFtmo6/Jgvhagw='
WHERE
key_id = '85f5336e20f6366aa356eb342188e207e8c01daeb7d443d83e598d2277b8a945'
AND (
token = 'C6+sKTgHUzynq35QLpshOUg1Xh8YuLFtmo6/Jgvhagw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)