UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'i9XMpk5wfB5mZqy3GlP9kgQ+2cFZFF7SJs1hEnE8hZs=' 
WHERE 
  key_id = '71de5cd2ead9f32d0c31291b6fc2ed2184f6b6a1f8bfec1dc6c30ee781dcbd45' 
  AND (
    token = 'i9XMpk5wfB5mZqy3GlP9kgQ+2cFZFF7SJs1hEnE8hZs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028