UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zKLNJKYxYnn1JRCXbw68vJMMoboqHnqxWc8ylR0O9AE='
WHERE
key_id = '7fb4aff707cc21ead5d160f7bdd363cf4cfbb5b5764e87c8f8f5dfb8372009c8'
AND (
token = 'zKLNJKYxYnn1JRCXbw68vJMMoboqHnqxWc8ylR0O9AE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)