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