UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vzKjL8/SpbuezVnYP0JUFr9ekVZxcGFXQR8g75dWOHA='
WHERE
key_id = '42d00674e3f5652d0f6b4b2f49ba9c098679b168e0cb2cb1946e65b5c3130caf'
AND (
token = 'vzKjL8/SpbuezVnYP0JUFr9ekVZxcGFXQR8g75dWOHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)