UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '9zFCFDI9mB5fyuv2+inUINyXkfkEbHJF57icrzloJGA=' 
WHERE 
  key_id = 'dfe0b59f50fec8a9c0bab8ca6cd4d3476d11d4d7f23908cbb9e899860b6b46dd' 
  AND (
    token = '9zFCFDI9mB5fyuv2+inUINyXkfkEbHJF57icrzloJGA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031