UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2JJqtGGGYi9bPJ5UNmL4Fn758CPA1Yc2xLKf/8dng7Y='
WHERE
key_id = 'b6ad00b9cf0e79d5d799198bb3bf23c9d2a43995cad5071485b27b2f29e6b174'
AND (
token = '2JJqtGGGYi9bPJ5UNmL4Fn758CPA1Yc2xLKf/8dng7Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)