UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJ3B2qZNC9Vgf9z8LgNi5FBIJjMeq3nJlElolNh1N3c='
WHERE
key_id = '8d5614aa28a4a4a06e72006955818614ef498059ea4ca9d0a0c455307dd990c1'
AND (
token = 'zJ3B2qZNC9Vgf9z8LgNi5FBIJjMeq3nJlElolNh1N3c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)