UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2Pqn8vc3doNxYUZ/QRgaqKZIssV8RTe7ppvTjcY2PHs='
WHERE
key_id = '036c9177f1eee60a8802169a350b47b93868aa5d1bf1b960ef0034936406edfc'
AND (
token = '2Pqn8vc3doNxYUZ/QRgaqKZIssV8RTe7ppvTjcY2PHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)