UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pYNrfMI3mLIWbhvNCVzIAOE5WeJeA6RldN4enMFgUwM='
WHERE
key_id = 'e43432df59a7f1e0f8d4470da36df4aaad75bdf1e4782f01d1c948dc164d9f27'
AND (
token = 'pYNrfMI3mLIWbhvNCVzIAOE5WeJeA6RldN4enMFgUwM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)