UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8eoR1z0UZQYBf43tN8pFWI3oeT2RkaEACb2XUPFUt/8='
WHERE
key_id = '1a31e59700dfd44f9e0fa1fef94df87872f0f8cce529dce95074717f1562312d'
AND (
token = '8eoR1z0UZQYBf43tN8pFWI3oeT2RkaEACb2XUPFUt/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)