UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1w8L7z8cYF3SIyws4fiAzJEthsiqy8N+d0K1A73b7+M='
WHERE
key_id = 'dbb39fae3d820bd2af6dc89b586ad08f72af09c3942ca392e50a37f3b65ee193'
AND (
token = '1w8L7z8cYF3SIyws4fiAzJEthsiqy8N+d0K1A73b7+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)