UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dTLHfe67ADntzfhXPDq/bIiqNbGFqJGpkubSRvvhAOw='
WHERE
key_id = 'e6a0e9482f7edd5fca1657a7cf14a26dece4a6fb9261f57c1485eb68074dffcf'
AND (
token = 'dTLHfe67ADntzfhXPDq/bIiqNbGFqJGpkubSRvvhAOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)