UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cNPNDZ5zvXDJWVqWSu1S/iZWEjBqmHs6JpgSU1HIjrQ='
WHERE
key_id = 'f8f6980076e6c8eda89fb2f0a66b5aeca4fba8f527cea5f42f3e51a6a4d24a80'
AND (
token = 'cNPNDZ5zvXDJWVqWSu1S/iZWEjBqmHs6JpgSU1HIjrQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)